<?php

//Yii::import('vinculacion.models.*');
class RepTrabajoCampoController extends AweController {

    /**
     * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
     * using two-column layout. See 'protected/views/layouts/column2.php'.
     */
    public $layout = '//layouts/column2';
    public $defaultAction = 'admin';

    public function filters() {
        return array(
            array('CrugeAccessControlFilter'),
        );
    }

    /**
     * Displays a particular model.
     * @param integer $id the ID of the model to be displayed
     */
    public function actionView($id) {

        $this->render('view', array(
            'model' => $this->loadModel($id),
        ));
    }

    /**
     * Creates a new model.
     * If creation is successful, the browser will be redirected to the 'view' page.
     */
    public function actionCreate() {
        $model = new RepTrabajoCampo;

        if (isset($_POST['RepTrabajoCampo'])) {
            $model->attributes = $_POST['RepTrabajoCampo'];
            $model->id_ficha = Ficha::model()->cedulaaid($model->cedula);

            $horasCumplidas = $model->horasCumplidas($model->id_area, $model->id_ficha);
            //totales horas de aqel id de area
            $horasArea = Area::model()->findByAttributes(array('id' => $model->id_area))->num_horas;

            $porCumplir = $horasArea - $horasCumplidas;

            if ($model->n_horas > $porCumplir || $model->n_horas < 1) {
                Yii::app()->user->setFlash('error', 'El numero de horas ingresadas no puede ser menor a 1 o mayor al numero de horas por cumplir');
            } else {
                if ($model->save()) {
                    $this->redirect(array('view', 'id' => $model->id));
                }
            }
        }

        $this->render('create', array(
            'model' => $model,
        ));
    }

    /**
     * Updates a particular model.
     * If update is successful, the browser will be redirected to the 'view' page.
     * @param integer $id the ID of the model to be updated
     */
    public function actionUpdate($id) {

        $model = $this->loadModel($id);


        if (isset($_POST['RepTrabajoCampo'])) {
            $horas = $model->n_horas;
            $model->attributes = $_POST['RepTrabajoCampo'];
            $model->id_ficha = Ficha::model()->cedulaaid($model->cedula);
            $horasCumplidas = $model->horasCumplidas($model->id_area, $model->id_ficha);
            //totales horas de aqel id de area
            $horasArea = Area::model()->findByAttributes(array('id' => $model->id_area))->num_horas;

            $porCumplir = $horasArea - $horasCumplidas + $horas;
            if ($model->n_horas > $porCumplir || $model->n_horas < 1) {
                Yii::app()->user->setFlash('error', 'El numero de horas ingresadas no puede ser 0 o mayor al numero de horas por cumplir');
            } else {
                if ($model->save()) {

                    $this->redirect(array('view', 'id' => $model->id));
                }
            }
        }


        $this->render('update', array(
            'model' => $model,
        ));
    }

    /**
     * Deletes a particular model.
     * If deletion is successful, the browser will be redirected to the 'admin' page.
     * @param integer $id the ID of the model to be deleted
     */
    public function actionDelete($id) {
        if (Yii::app()->request->isPostRequest) {
            // we only allow deletion via POST request
            $this->loadModel($id)->delete();

            // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
            if (!isset($_GET['ajax']))
                $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
        } else
            throw new CHttpException(400, 'Invalid request. Please do not repeat this request again.');
    }

    /**
     * Lists all models.
     */
    public function actionIndex() {
        $dataProvider = new CActiveDataProvider('RepTrabajoCampo');
        $this->render('index', array(
            'dataProvider' => $dataProvider,
        ));
    }

    /**
     * Manages all models.
     */
    public function actionAdmin() {
        $model = new RepTrabajoCampo('search');
        $model->unsetAttributes(); // clear any default values
        if (isset($_GET['RepTrabajoCampo']))
            $model->attributes = $_GET['RepTrabajoCampo'];

        $this->render('admin', array(
            'model' => $model,
        ));
    }

    /**
     * Returns the data model based on the primary key given in the GET variable.
     * If the data model is not found, an HTTP exception will be raised.
     * @param integer the ID of the model to be loaded
     */
    public function loadModel($id, $modelClass = __CLASS__) {
        $model = RepTrabajoCampo::model()->findByPk($id);
        $model->cedula = $model->idFicha->cedula;
        if ($model === null)
            throw new CHttpException(404, 'The requested page does not exist.');
        return $model;
    }

    /**
     * Performs the AJAX validation.
     * @param CModel the model to be validated
     */
    protected function performAjaxValidation($model, $form = null) {
        if (isset($_POST['ajax']) && $_POST['ajax'] === 'rep-trabajo-campo-form') {
            echo CActiveForm::validate($model);
            Yii::app()->end();
        }
    }

    public function actionListaCedulas() {

        $request = trim($_GET['term']);

        if ($request != '') {

            $fichas = Ficha::model()->findAll(array("condition" => "cedula like '%$request%'"));

            $data = array();

            foreach ($fichas as $ficha) {

                $data[] = array(
                    'label' => $ficha->cedula . ' - ' . $ficha->apellidos . ' ' . $ficha->nombres, // label for dropdown list
                    'value' => $ficha->cedula, // value for input field
                );
            }

            $this->layout = 'empty';

            echo json_encode($data);
        }
    }

    public function actionListaAreas($cedula) {
        $ficha = Ficha::model()->findByAttributes(array('cedula' => $cedula));
        $listarea[] = "<option value=''>- Seleccione un Area -</option>";

        if (isset($ficha)) {

            $areas = $ficha->idCarrera->areas;
            foreach ($areas as $area) {
                $id = $area->id;
                if (!($id == 4 || $id == 12 || $id == 19 || $id == 8 || $id == 16 || $id == 24)) {
                    $listarea[] = "<option value='" . $area->id . "'>" . $area->nombre . "</option>";
                }
            }
        }
        print json_encode($listarea);
    }

    public function actionObtenerHorasTotales() {
        $informeHoras;
        $model = new RepTrabajoCampo();
        if (!empty($_POST['RepTrabajoCampo']['id_area']) && !empty($_POST['RepTrabajoCampo']['cedula'])) {//obtener l id del dropdownlist 
            //cedula del post y asi encontrar el id de esa cedula es decir l id d la ficha
            $ficha = Ficha::model()->cedulaaid($_POST['RepTrabajoCampo']['cedula']);
            //id del area post
            $area = $_POST['RepTrabajoCampo']['id_area'];
            //encontrar todos los trabajos de campos q ha realizado
            $horasCumplidas = $model->horasCumplidas($area, $ficha);
            //totales horas de aqel id de area
            $totalHorasAreasegunID = Area::model()->findByAttributes(array('id' => $area))->num_horas;

            $informeHoras = '<div> Total: ' . $totalHorasAreasegunID . '</div>'
                    . '<div> Cumplidas: ' . $horasCumplidas . '</div>'
                    . '<div> Por cumplir: ' . ($totalHorasAreasegunID - $horasCumplidas) . '</div>';
            print $informeHoras;
        }
    }

}
